var LvmamaSQL = {
	insertScenic: 'insert into scenic(itemId,itemHref,itemImg,itemTitle,itemCity,itemLocal,itemPrice,itemCommentLevel) VALUES(?,?,?,?,?,?,?,?)',
	insertTicket: 'insert into ticket(scenicId,goodsId,title,price,lvprice) VALUES(?,?,?,?,?)',
}
/*
 * CREATE DATABASE `lvmama` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;  
// 景点列表
CREATE TABLE IF NOT EXISTS scenic (   11380
  id INT(11) NOT NULL AUTO_INCREMENT,
  itemId VARCHAR(45) NOT NULL,
  itemHref TEXT NOT NULL,
  itemImg TEXT NOT NULL,
  itemTitle TEXT NOT NULL,
  itemProvice TEXT NOT NULL,
  itemCity TEXT NOT NULL,
  itemLocal TEXT NOT NULL,
  itemPrice TEXT NOT NULL,
  itemCommentLevel TEXT NOT NULL,
  PRIMARY KEY (id),
  UNIQUE (itemId)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
// 景点门票
CREATE TABLE IF NOT EXISTS ticket (   14887
  id INT(11) NOT NULL AUTO_INCREMENT,
  scenicId VARCHAR(45) NOT NULL,
  goodsId VARCHAR(45) NOT NULL,
  title TEXT NOT NULL,
  price TEXT NOT NULL,
  lvprice TEXT NOT NULL,
  PRIMARY KEY (id),
  UNIQUE (goodsId)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
// 全部旅游
CREATE TABLE IF NOT EXISTS route (  25461
  id INT(11) NOT NULL AUTO_INCREMENT,
  itemId VARCHAR(45) NOT NULL,
  itemHref TEXT NOT NULL,
  itemImg TEXT NOT NULL,
  itemProvice TEXT NOT NULL,
  itemType TEXT NOT NULL,
  itemTitle TEXT NOT NULL,
  itemPrice TEXT NOT NULL,
  itemCommentLevel TEXT NOT NULL,
  PRIMARY KEY (id),
  UNIQUE (itemId)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
// 酒店+景点
CREATE TABLE IF NOT EXISTS scenictour (  // 7024
  id INT(11) NOT NULL AUTO_INCREMENT,
  itemId VARCHAR(45) NOT NULL,
  itemHref TEXT NOT NULL,
  itemImg TEXT NOT NULL,
  itemProvice TEXT NOT NULL,
  itemType TEXT NOT NULL,
  itemTitle TEXT NOT NULL,
  itemPrice TEXT NOT NULL,
  itemCommentLevel TEXT NOT NULL,
  PRIMARY KEY (id),
  UNIQUE (itemId)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
// 出发地参团
CREATE TABLE IF NOT EXISTS groupTb (  11251
  id INT(11) NOT NULL AUTO_INCREMENT,
  itemId VARCHAR(45) NOT NULL,
  itemHref TEXT NOT NULL,
  itemImg TEXT NOT NULL,
  itemProvice TEXT NOT NULL,
  itemType TEXT NOT NULL,
  itemTitle TEXT NOT NULL,
  itemPrice TEXT NOT NULL,
  itemCommentLevel TEXT NOT NULL,
  PRIMARY KEY (id),
  UNIQUE (itemId)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
// 自由行
CREATE TABLE IF NOT EXISTS freetour (  10189
  id INT(11) NOT NULL AUTO_INCREMENT,
  itemId VARCHAR(45) NOT NULL,
  itemHref TEXT NOT NULL,
  itemImg TEXT NOT NULL,
  itemProvice TEXT NOT NULL,
  itemType TEXT NOT NULL,
  itemTitle TEXT NOT NULL,
  itemPrice TEXT NOT NULL,
  itemCommentLevel TEXT NOT NULL,
  PRIMARY KEY (id),
  UNIQUE (itemId)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


drop table ticket;
drop table scenic;
drop table route;
select * from ticket;
select * from scenic;
select * from route;
delete from ticket;
delete from scenic;
delete from route;
*/
//insert ignore into scenic(itemId,itemHref,itemImg,itemTitle,itemCity,itemLocal,itemPrice,itemCommentLevel) VALUES('10597202','http://ticket.lvmama.com/scenic-10597202','http://pic.lvmama.com//uploads/pc/place2/2015-03-17/51161077-b231-4b15-b371-3dc4f13f04b2_180_120.jpg','上海超龙游乐场（顾村公园店）',' [上海·宝山区] ','上海市宝山区沪太路4788号','80起','96%');
//10189
//11251
//7024
//25461
//14887
//11380
//80192